﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="alpha_dbStudentDataSet" targetNamespace="http://tempuri.org/alpha_dbStudentDataSet.xsd" xmlns:mstns="http://tempuri.org/alpha_dbStudentDataSet.xsd" xmlns="http://tempuri.org/alpha_dbStudentDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="alpha_dbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="alpha_dbConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.AlphaSolutionsGP.Properties.Settings.GlobalReference.Default.alpha_dbConnectionString" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="STUDENTTableAdapter" GeneratorDataComponentClassName="STUDENTTableAdapter" Name="STUDENT" UserDataComponentName="STUDENTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.STUDENT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `STUDENT` WHERE ((`student_ID` = @Original_student_ID) AND ((@IsNull_COURSE_course_Code = 1 AND `COURSE_course_Code` IS NULL) OR (`COURSE_course_Code` = @Original_COURSE_course_Code)) AND (`level` = @Original_level) AND (`name` = @Original_name) AND ((@IsNull_middle_name = 1 AND `middle_name` IS NULL) OR (`middle_name` = @Original_middle_name)) AND (`surname` = @Original_surname) AND (`DOB` = @Original_DOB) AND (`nationality` = @Original_nationality) AND (`home_town` = @Original_home_town) AND (`street_address` = @Original_street_address) AND (`postcode` = @Original_postcode) AND (`city` = @Original_city) AND ((@IsNull_mobile_number = 1 AND `mobile_number` IS NULL) OR (`mobile_number` = @Original_mobile_number)) AND ((@IsNull_telephone_number = 1 AND `telephone_number` IS NULL) OR (`telephone_number` = @Original_telephone_number)) AND (`date_enrolment` = @Original_date_enrolment) AND (`date_graduation` = @Original_date_graduation) AND (`status` = @Original_status) AND (`email_address` = @Original_email_address) AND (`password` = @Original_password) AND ((@IsNull_image_location = 1 AND `image_location` IS NULL) OR (`image_location` = @Original_image_location)) AND (`assigned_email` = @Original_assigned_email))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COURSE_course_Code" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COURSE_course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_level" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="level" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_middle_name" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_surname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DOB" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nationality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_home_town" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="home_town" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_street_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="street_address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_postcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="postcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mobile_number" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="mobile_number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mobile_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="mobile_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telephone_number" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="telephone_number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telephone_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telephone_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_enrolment" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_enrolment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_graduation" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_graduation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email_address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_image_location" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="image_location" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_image_location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="image_location" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_assigned_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="assigned_email" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `STUDENT` (`student_ID`, `COURSE_course_Code`, `level`, `name`, `middle_name`, `surname`, `DOB`, `nationality`, `home_town`, `street_address`, `postcode`, `city`, `mobile_number`, `telephone_number`, `date_enrolment`, `date_graduation`, `status`, `email_address`, `password`, `image_location`, `assigned_email`) VALUES (@student_ID, @COURSE_course_Code, @level, @name, @middle_name, @surname, @DOB, @nationality, @home_town, @street_address, @postcode, @city, @mobile_number, @telephone_number, @date_enrolment, @date_graduation, @status, @email_address, @password, @image_location, @assigned_email)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COURSE_course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@level" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@surname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DOB" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nationality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@home_town" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="home_town" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@street_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="street_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@postcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="postcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mobile_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="mobile_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telephone_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telephone_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_enrolment" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_enrolment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_graduation" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_graduation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@image_location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="image_location" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@assigned_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="assigned_email" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT student_ID, COURSE_course_Code, level, name, middle_name, surname, DOB, nationality, home_town, street_address, postcode, city, mobile_number, telephone_number, date_enrolment, date_graduation, status, email_address, password, image_location, assigned_email FROM STUDENT</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `STUDENT` SET `student_ID` = @student_ID, `COURSE_course_Code` = @COURSE_course_Code, `level` = @level, `name` = @name, `middle_name` = @middle_name, `surname` = @surname, `DOB` = @DOB, `nationality` = @nationality, `home_town` = @home_town, `street_address` = @street_address, `postcode` = @postcode, `city` = @city, `mobile_number` = @mobile_number, `telephone_number` = @telephone_number, `date_enrolment` = @date_enrolment, `date_graduation` = @date_graduation, `status` = @status, `email_address` = @email_address, `password` = @password, `image_location` = @image_location, `assigned_email` = @assigned_email WHERE ((`student_ID` = @Original_student_ID) AND ((@IsNull_COURSE_course_Code = 1 AND `COURSE_course_Code` IS NULL) OR (`COURSE_course_Code` = @Original_COURSE_course_Code)) AND (`level` = @Original_level) AND (`name` = @Original_name) AND ((@IsNull_middle_name = 1 AND `middle_name` IS NULL) OR (`middle_name` = @Original_middle_name)) AND (`surname` = @Original_surname) AND (`DOB` = @Original_DOB) AND (`nationality` = @Original_nationality) AND (`home_town` = @Original_home_town) AND (`street_address` = @Original_street_address) AND (`postcode` = @Original_postcode) AND (`city` = @Original_city) AND ((@IsNull_mobile_number = 1 AND `mobile_number` IS NULL) OR (`mobile_number` = @Original_mobile_number)) AND ((@IsNull_telephone_number = 1 AND `telephone_number` IS NULL) OR (`telephone_number` = @Original_telephone_number)) AND (`date_enrolment` = @Original_date_enrolment) AND (`date_graduation` = @Original_date_graduation) AND (`status` = @Original_status) AND (`email_address` = @Original_email_address) AND (`password` = @Original_password) AND ((@IsNull_image_location = 1 AND `image_location` IS NULL) OR (`image_location` = @Original_image_location)) AND (`assigned_email` = @Original_assigned_email))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COURSE_course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@level" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@surname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DOB" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nationality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@home_town" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="home_town" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@street_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="street_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@postcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="postcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mobile_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="mobile_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telephone_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telephone_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_enrolment" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_enrolment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_graduation" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_graduation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@image_location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="image_location" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@assigned_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="assigned_email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COURSE_course_Code" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COURSE_course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_level" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="level" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_middle_name" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_surname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DOB" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nationality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_home_town" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="home_town" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_street_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="street_address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_postcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="postcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mobile_number" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="mobile_number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mobile_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="mobile_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telephone_number" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="telephone_number" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telephone_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telephone_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_enrolment" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_enrolment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_graduation" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_graduation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email_address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_image_location" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="image_location" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_image_location" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="image_location" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_assigned_email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="assigned_email" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="student_ID" DataSetColumn="student_ID" />
              <Mapping SourceColumn="COURSE_course_Code" DataSetColumn="COURSE_course_Code" />
              <Mapping SourceColumn="level" DataSetColumn="level" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="middle_name" DataSetColumn="middle_name" />
              <Mapping SourceColumn="surname" DataSetColumn="surname" />
              <Mapping SourceColumn="DOB" DataSetColumn="DOB" />
              <Mapping SourceColumn="nationality" DataSetColumn="nationality" />
              <Mapping SourceColumn="home_town" DataSetColumn="home_town" />
              <Mapping SourceColumn="street_address" DataSetColumn="street_address" />
              <Mapping SourceColumn="postcode" DataSetColumn="postcode" />
              <Mapping SourceColumn="city" DataSetColumn="city" />
              <Mapping SourceColumn="mobile_number" DataSetColumn="mobile_number" />
              <Mapping SourceColumn="telephone_number" DataSetColumn="telephone_number" />
              <Mapping SourceColumn="date_enrolment" DataSetColumn="date_enrolment" />
              <Mapping SourceColumn="date_graduation" DataSetColumn="date_graduation" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="email_address" DataSetColumn="email_address" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="image_location" DataSetColumn="image_location" />
              <Mapping SourceColumn="assigned_email" DataSetColumn="assigned_email" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ASSESSMENTTableAdapter" GeneratorDataComponentClassName="ASSESSMENTTableAdapter" Name="ASSESSMENT" UserDataComponentName="ASSESSMENTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.ASSESSMENT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ASSESSMENT` WHERE ((`assessment_ID` = @Original_assessment_ID) AND (`MODULE_module_Code` = @Original_MODULE_module_Code) AND (`status` = @Original_status) AND (`hand_out_date` = @Original_hand_out_date) AND (`due_in_date` = @Original_due_in_date) AND (`weighting_percentage` = @Original_weighting_percentage) AND (`type` = @Original_type) AND ((@IsNull_description = 1 AND `description` IS NULL) OR (`description` = @Original_description)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_assessment_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="assessment_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_hand_out_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="hand_out_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_due_in_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="due_in_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_weighting_percentage" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="weighting_percentage" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_description" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ASSESSMENT` (`MODULE_module_Code`, `status`, `hand_out_date`, `due_in_date`, `weighting_percentage`, `type`, `description`) VALUES (@MODULE_module_Code, @status, @hand_out_date, @due_in_date, @weighting_percentage, @type, @description)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@hand_out_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="hand_out_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@due_in_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="due_in_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@weighting_percentage" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="weighting_percentage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT assessment_ID, MODULE_module_Code, status, hand_out_date, due_in_date, weighting_percentage, type, description FROM ASSESSMENT</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ASSESSMENT` SET `MODULE_module_Code` = @MODULE_module_Code, `status` = @status, `hand_out_date` = @hand_out_date, `due_in_date` = @due_in_date, `weighting_percentage` = @weighting_percentage, `type` = @type, `description` = @description WHERE ((`assessment_ID` = @Original_assessment_ID) AND (`MODULE_module_Code` = @Original_MODULE_module_Code) AND (`status` = @Original_status) AND (`hand_out_date` = @Original_hand_out_date) AND (`due_in_date` = @Original_due_in_date) AND (`weighting_percentage` = @Original_weighting_percentage) AND (`type` = @Original_type) AND ((@IsNull_description = 1 AND `description` IS NULL) OR (`description` = @Original_description)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@hand_out_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="hand_out_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@due_in_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="due_in_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@weighting_percentage" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="weighting_percentage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_assessment_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="assessment_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_hand_out_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="hand_out_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_due_in_date" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="due_in_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_weighting_percentage" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="weighting_percentage" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_description" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="assessment_ID" DataSetColumn="assessment_ID" />
              <Mapping SourceColumn="MODULE_module_Code" DataSetColumn="MODULE_module_Code" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="hand_out_date" DataSetColumn="hand_out_date" />
              <Mapping SourceColumn="due_in_date" DataSetColumn="due_in_date" />
              <Mapping SourceColumn="weighting_percentage" DataSetColumn="weighting_percentage" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ASSIGNEDTableAdapter" GeneratorDataComponentClassName="ASSIGNEDTableAdapter" Name="ASSIGNED" UserDataComponentName="ASSIGNEDTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.ASSIGNED" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ASSIGNED` WHERE ((`assigned_ID` = @Original_assigned_ID) AND (`SLOT_slot_ID` = @Original_SLOT_slot_ID) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID) AND (`group_Number` = @Original_group_Number) AND (`MODULE_module_Code` = @Original_MODULE_module_Code))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_assigned_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="assigned_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SLOT_slot_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="SLOT_slot_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_group_Number" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="group_Number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ASSIGNED` (`SLOT_slot_ID`, `STUDENT_student_ID`, `group_Number`, `MODULE_module_Code`) VALUES (@SLOT_slot_ID, @STUDENT_student_ID, @group_Number, @MODULE_module_Code)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SLOT_slot_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="SLOT_slot_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@group_Number" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="group_Number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `assigned_ID`, `SLOT_slot_ID`, `STUDENT_student_ID`, `group_Number`, `MODULE_module_Code` FROM `ASSIGNED`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ASSIGNED` SET `SLOT_slot_ID` = @SLOT_slot_ID, `STUDENT_student_ID` = @STUDENT_student_ID, `group_Number` = @group_Number, `MODULE_module_Code` = @MODULE_module_Code WHERE ((`assigned_ID` = @Original_assigned_ID) AND (`SLOT_slot_ID` = @Original_SLOT_slot_ID) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID) AND (`group_Number` = @Original_group_Number) AND (`MODULE_module_Code` = @Original_MODULE_module_Code))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SLOT_slot_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="SLOT_slot_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@group_Number" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="group_Number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_assigned_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="assigned_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SLOT_slot_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="SLOT_slot_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_group_Number" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="group_Number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="assigned_ID" DataSetColumn="assigned_ID" />
              <Mapping SourceColumn="SLOT_slot_ID" DataSetColumn="SLOT_slot_ID" />
              <Mapping SourceColumn="STUDENT_student_ID" DataSetColumn="STUDENT_student_ID" />
              <Mapping SourceColumn="group_Number" DataSetColumn="group_Number" />
              <Mapping SourceColumn="MODULE_module_Code" DataSetColumn="MODULE_module_Code" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CONCERN_LETTERTableAdapter" GeneratorDataComponentClassName="CONCERN_LETTERTableAdapter" Name="CONCERN_LETTER" UserDataComponentName="CONCERN_LETTERTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.CONCERN_LETTER" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `CONCERN_LETTER` WHERE ((`letter_ID` = @Original_letter_ID) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID) AND (`motivation` = @Original_motivation) AND (`date_sent` = @Original_date_sent) AND (`contact_due_date` = @Original_contact_due_date) AND (`status` = @Original_status))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_letter_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="letter_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_motivation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="motivation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_sent" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_sent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_contact_due_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="contact_due_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `CONCERN_LETTER` (`STUDENT_student_ID`, `motivation`, `date_sent`, `contact_due_date`, `status`) VALUES (@STUDENT_student_ID, @motivation, @date_sent, @contact_due_date, @status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@motivation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="motivation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_sent" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_sent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@contact_due_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="contact_due_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `letter_ID`, `STUDENT_student_ID`, `motivation`, `date_sent`, `contact_due_date`, `status` FROM `CONCERN_LETTER`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `CONCERN_LETTER` SET `STUDENT_student_ID` = @STUDENT_student_ID, `motivation` = @motivation, `date_sent` = @date_sent, `contact_due_date` = @contact_due_date, `status` = @status WHERE ((`letter_ID` = @Original_letter_ID) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID) AND (`motivation` = @Original_motivation) AND (`date_sent` = @Original_date_sent) AND (`contact_due_date` = @Original_contact_due_date) AND (`status` = @Original_status))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@motivation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="motivation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_sent" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_sent" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@contact_due_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="contact_due_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_letter_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="letter_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_motivation" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="motivation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_sent" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_sent" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_contact_due_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="contact_due_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="letter_ID" DataSetColumn="letter_ID" />
              <Mapping SourceColumn="STUDENT_student_ID" DataSetColumn="STUDENT_student_ID" />
              <Mapping SourceColumn="motivation" DataSetColumn="motivation" />
              <Mapping SourceColumn="date_sent" DataSetColumn="date_sent" />
              <Mapping SourceColumn="contact_due_date" DataSetColumn="contact_due_date" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="COURSETableAdapter" GeneratorDataComponentClassName="COURSETableAdapter" Name="COURSE" UserDataComponentName="COURSETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.COURSE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `COURSE` WHERE ((`course_Code` = @Original_course_Code) AND (`title` = @Original_title) AND (`year` = @Original_year) AND (`department` = @Original_department) AND (`max_students` = @Original_max_students) AND (`description` = @Original_description) AND (`requirements` = @Original_requirements))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="course_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_year" Precision="0" ProviderType="Year" Scale="0" Size="0" SourceColumn="year" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_department" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="department" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_max_students" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="max_students" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_requirements" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="requirements" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `COURSE` (`course_Code`, `title`, `year`, `department`, `max_students`, `description`, `requirements`) VALUES (@course_Code, @title, @year, @department, @max_students, @description, @requirements)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="course_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@year" Precision="0" ProviderType="Year" Scale="0" Size="0" SourceColumn="year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@department" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="department" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@max_students" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="max_students" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@requirements" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="requirements" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT course_Code, title, year, department, max_students, description, requirements FROM COURSE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `COURSE` SET `course_Code` = @course_Code, `title` = @title, `year` = @year, `department` = @department, `max_students` = @max_students, `description` = @description, `requirements` = @requirements WHERE ((`course_Code` = @Original_course_Code) AND (`title` = @Original_title) AND (`year` = @Original_year) AND (`department` = @Original_department) AND (`max_students` = @Original_max_students) AND (`description` = @Original_description) AND (`requirements` = @Original_requirements))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="course_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@year" Precision="0" ProviderType="Year" Scale="0" Size="0" SourceColumn="year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@department" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="department" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@max_students" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="max_students" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@requirements" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="requirements" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="course_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_year" Precision="0" ProviderType="Year" Scale="0" Size="0" SourceColumn="year" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_department" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="department" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_max_students" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="max_students" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_requirements" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="requirements" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="course_Code" DataSetColumn="course_Code" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="year" DataSetColumn="year" />
              <Mapping SourceColumn="department" DataSetColumn="department" />
              <Mapping SourceColumn="max_students" DataSetColumn="max_students" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="requirements" DataSetColumn="requirements" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EVENTTableAdapter" GeneratorDataComponentClassName="EVENTTableAdapter" Name="EVENT" UserDataComponentName="EVENTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.EVENT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `EVENT` WHERE ((`event_ID` = @Original_event_ID) AND (`name` = @Original_name) AND (`description` = @Original_description) AND (`date` = @Original_date) AND (`time` = @Original_time) AND (`priority` = @Original_priority) AND ((@IsNull_STUDENT_student_ID = 1 AND `STUDENT_student_ID` IS NULL) OR (`STUDENT_student_ID` = @Original_STUDENT_student_ID)) AND ((@IsNull_STAFF_staff_ID = 1 AND `STAFF_staff_ID` IS NULL) OR (`STAFF_staff_ID` = @Original_STAFF_staff_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_event_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="event_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@Original_time" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="time" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_priority" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="priority" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STUDENT_student_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STAFF_staff_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `EVENT` (`name`, `description`, `date`, `time`, `priority`, `STUDENT_student_ID`, `STAFF_staff_ID`) VALUES (@name, @description, @date, @time, @priority, @STUDENT_student_ID, @STAFF_staff_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@time" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="time" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@priority" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `event_ID`, `name`, `description`, `date`, `time`, `priority`, `STUDENT_student_ID`, `STAFF_staff_ID` FROM `EVENT`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `EVENT` SET `name` = @name, `description` = @description, `date` = @date, `time` = @time, `priority` = @priority, `STUDENT_student_ID` = @STUDENT_student_ID, `STAFF_staff_ID` = @STAFF_staff_ID WHERE ((`event_ID` = @Original_event_ID) AND (`name` = @Original_name) AND (`description` = @Original_description) AND (`date` = @Original_date) AND (`time` = @Original_time) AND (`priority` = @Original_priority) AND ((@IsNull_STUDENT_student_ID = 1 AND `STUDENT_student_ID` IS NULL) OR (`STUDENT_student_ID` = @Original_STUDENT_student_ID)) AND ((@IsNull_STAFF_staff_ID = 1 AND `STAFF_staff_ID` IS NULL) OR (`STAFF_staff_ID` = @Original_STAFF_staff_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@time" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="time" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@priority" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="priority" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_event_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="event_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@Original_time" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="time" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_priority" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="priority" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STUDENT_student_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_STAFF_staff_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="event_ID" DataSetColumn="event_ID" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="time" DataSetColumn="time" />
              <Mapping SourceColumn="priority" DataSetColumn="priority" />
              <Mapping SourceColumn="STUDENT_student_ID" DataSetColumn="STUDENT_student_ID" />
              <Mapping SourceColumn="STAFF_staff_ID" DataSetColumn="STAFF_staff_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MODULETableAdapter" GeneratorDataComponentClassName="MODULETableAdapter" Name="MODULE" UserDataComponentName="MODULETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.MODULE" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `MODULE` WHERE ((`module_Code` = @Original_module_Code) AND ((@IsNull_COURSE_course_Code = 1 AND `COURSE_course_Code` IS NULL) OR (`COURSE_course_Code` = @Original_COURSE_course_Code)) AND (`title` = @Original_title) AND (`field` = @Original_field) AND (`description` = @Original_description) AND (`credits` = @Original_credits) AND (`STAFF_staff_ID` = @Original_STAFF_staff_ID) AND (`level` = @Original_level))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="module_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COURSE_course_Code" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COURSE_course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_field" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="field" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_credits" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="credits" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_level" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="level" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `MODULE` (`module_Code`, `COURSE_course_Code`, `title`, `field`, `description`, `credits`, `STAFF_staff_ID`, `level`) VALUES (@module_Code, @COURSE_course_Code, @title, @field, @description, @credits, @STAFF_staff_ID, @level)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="module_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COURSE_course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@field" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="field" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@credits" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="credits" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@level" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="level" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT module_Code, COURSE_course_Code, title, field, description, credits, STAFF_staff_ID, level FROM MODULE</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `MODULE` SET `module_Code` = @module_Code, `COURSE_course_Code` = @COURSE_course_Code, `title` = @title, `field` = @field, `description` = @description, `credits` = @credits, `STAFF_staff_ID` = @STAFF_staff_ID, `level` = @level WHERE ((`module_Code` = @Original_module_Code) AND ((@IsNull_COURSE_course_Code = 1 AND `COURSE_course_Code` IS NULL) OR (`COURSE_course_Code` = @Original_COURSE_course_Code)) AND (`title` = @Original_title) AND (`field` = @Original_field) AND (`description` = @Original_description) AND (`credits` = @Original_credits) AND (`STAFF_staff_ID` = @Original_STAFF_staff_ID) AND (`level` = @Original_level))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="module_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COURSE_course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@field" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="field" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@credits" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="credits" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@level" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="module_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_COURSE_course_Code" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_COURSE_course_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="COURSE_course_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_field" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="field" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_credits" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="credits" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_level" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="level" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="module_Code" DataSetColumn="module_Code" />
              <Mapping SourceColumn="COURSE_course_Code" DataSetColumn="COURSE_course_Code" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="field" DataSetColumn="field" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="credits" DataSetColumn="credits" />
              <Mapping SourceColumn="STAFF_staff_ID" DataSetColumn="STAFF_staff_ID" />
              <Mapping SourceColumn="level" DataSetColumn="level" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PERSONAL_TUTORIALTableAdapter" GeneratorDataComponentClassName="PERSONAL_TUTORIALTableAdapter" Name="PERSONAL_TUTORIAL" UserDataComponentName="PERSONAL_TUTORIALTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.PERSONAL_TUTORIAL" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `PERSONAL_TUTORIAL` WHERE ((`pt_ID` = @Original_pt_ID) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID) AND (`STAFF_staff_ID` = @Original_STAFF_staff_ID) AND (`title` = @Original_title) AND (`term` = @Original_term) AND (`date_time` = @Original_date_time) AND (`description` = @Original_description) AND (`status` = @Original_status))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_pt_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pt_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_term" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="term" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_time" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_time" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `PERSONAL_TUTORIAL` (`STUDENT_student_ID`, `STAFF_staff_ID`, `title`, `term`, `date_time`, `description`, `status`) VALUES (@STUDENT_student_ID, @STAFF_staff_ID, @title, @term, @date_time, @description, @status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@term" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="term" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_time" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_time" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `pt_ID`, `STUDENT_student_ID`, `STAFF_staff_ID`, `title`, `term`, `date_time`, `description`, `status` FROM `PERSONAL_TUTORIAL`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `PERSONAL_TUTORIAL` SET `STUDENT_student_ID` = @STUDENT_student_ID, `STAFF_staff_ID` = @STAFF_staff_ID, `title` = @title, `term` = @term, `date_time` = @date_time, `description` = @description, `status` = @status WHERE ((`pt_ID` = @Original_pt_ID) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID) AND (`STAFF_staff_ID` = @Original_STAFF_staff_ID) AND (`title` = @Original_title) AND (`term` = @Original_term) AND (`date_time` = @Original_date_time) AND (`description` = @Original_description) AND (`status` = @Original_status))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@term" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="term" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_time" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_time" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_pt_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pt_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STAFF_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STAFF_staff_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_term" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="term" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_time" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_time" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="pt_ID" DataSetColumn="pt_ID" />
              <Mapping SourceColumn="STUDENT_student_ID" DataSetColumn="STUDENT_student_ID" />
              <Mapping SourceColumn="STAFF_staff_ID" DataSetColumn="STAFF_staff_ID" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="term" DataSetColumn="term" />
              <Mapping SourceColumn="date_time" DataSetColumn="date_time" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="QUALIFICATIONTableAdapter" GeneratorDataComponentClassName="QUALIFICATIONTableAdapter" Name="QUALIFICATION" UserDataComponentName="QUALIFICATIONTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.QUALIFICATION" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `QUALIFICATION` WHERE ((`id_Qualification` = @Original_id_Qualification) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID) AND (`type` = @Original_type) AND (`title` = @Original_title) AND (`subject` = @Original_subject) AND (`grade` = @Original_grade) AND (`date_achieved` = @Original_date_achieved))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_Qualification" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id_Qualification" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_subject" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="subject" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_grade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_achieved" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_achieved" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `QUALIFICATION` (`STUDENT_student_ID`, `type`, `title`, `subject`, `grade`, `date_achieved`) VALUES (@STUDENT_student_ID, @type, @title, @subject, @grade, @date_achieved)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@subject" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@grade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_achieved" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_achieved" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id_Qualification, STUDENT_student_ID, type, title, subject, grade, date_achieved FROM QUALIFICATION</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `QUALIFICATION` SET `STUDENT_student_ID` = @STUDENT_student_ID, `type` = @type, `title` = @title, `subject` = @subject, `grade` = @grade, `date_achieved` = @date_achieved WHERE ((`id_Qualification` = @Original_id_Qualification) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID) AND (`type` = @Original_type) AND (`title` = @Original_title) AND (`subject` = @Original_subject) AND (`grade` = @Original_grade) AND (`date_achieved` = @Original_date_achieved))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@subject" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@grade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_achieved" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_achieved" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_Qualification" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id_Qualification" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_title" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_subject" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="subject" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_grade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grade" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_achieved" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_achieved" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_Qualification" DataSetColumn="id_Qualification" />
              <Mapping SourceColumn="STUDENT_student_ID" DataSetColumn="STUDENT_student_ID" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="subject" DataSetColumn="subject" />
              <Mapping SourceColumn="grade" DataSetColumn="grade" />
              <Mapping SourceColumn="date_achieved" DataSetColumn="date_achieved" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="REGISTERTableAdapter" GeneratorDataComponentClassName="REGISTERTableAdapter" Name="REGISTER" UserDataComponentName="REGISTERTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.REGISTER" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `REGISTER` WHERE ((`register_ID` = @Original_register_ID) AND (`MODULE_module_Code` = @Original_MODULE_module_Code) AND (`date_creation` = @Original_date_creation) AND (`attendance` = @Original_attendance) AND (`WEEK_id_Week` = @Original_WEEK_id_Week) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_register_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="register_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_creation" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_creation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_attendance" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="attendance" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_WEEK_id_Week" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="WEEK_id_Week" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `REGISTER` (`MODULE_module_Code`, `date_creation`, `attendance`, `WEEK_id_Week`, `STUDENT_student_ID`) VALUES (@MODULE_module_Code, @date_creation, @attendance, @WEEK_id_Week, @STUDENT_student_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_creation" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_creation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@attendance" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="attendance" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@WEEK_id_Week" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="WEEK_id_Week" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `register_ID`, `MODULE_module_Code`, `date_creation`, `attendance`, `WEEK_id_Week`, `STUDENT_student_ID` FROM `REGISTER`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `REGISTER` SET `MODULE_module_Code` = @MODULE_module_Code, `date_creation` = @date_creation, `attendance` = @attendance, `WEEK_id_Week` = @WEEK_id_Week, `STUDENT_student_ID` = @STUDENT_student_ID WHERE ((`register_ID` = @Original_register_ID) AND (`MODULE_module_Code` = @Original_MODULE_module_Code) AND (`date_creation` = @Original_date_creation) AND (`attendance` = @Original_attendance) AND (`WEEK_id_Week` = @Original_WEEK_id_Week) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_creation" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_creation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@attendance" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="attendance" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@WEEK_id_Week" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="WEEK_id_Week" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_register_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="register_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_creation" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_creation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_attendance" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="attendance" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_WEEK_id_Week" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="WEEK_id_Week" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="register_ID" DataSetColumn="register_ID" />
              <Mapping SourceColumn="MODULE_module_Code" DataSetColumn="MODULE_module_Code" />
              <Mapping SourceColumn="date_creation" DataSetColumn="date_creation" />
              <Mapping SourceColumn="attendance" DataSetColumn="attendance" />
              <Mapping SourceColumn="WEEK_id_Week" DataSetColumn="WEEK_id_Week" />
              <Mapping SourceColumn="STUDENT_student_ID" DataSetColumn="STUDENT_student_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RESULTTableAdapter" GeneratorDataComponentClassName="RESULTTableAdapter" Name="RESULT" UserDataComponentName="RESULTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.RESULT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `RESULT` WHERE ((`result_ID` = @Original_result_ID) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID) AND (`ASSESSMENT_assessment_ID` = @Original_ASSESSMENT_assessment_ID) AND (`date_submission` = @Original_date_submission) AND (`grade` = @Original_grade))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_result_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="result_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ASSESSMENT_assessment_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ASSESSMENT_assessment_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_submission" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_submission" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_grade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grade" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `RESULT` (`STUDENT_student_ID`, `ASSESSMENT_assessment_ID`, `date_submission`, `grade`) VALUES (@STUDENT_student_ID, @ASSESSMENT_assessment_ID, @date_submission, @grade)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ASSESSMENT_assessment_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ASSESSMENT_assessment_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_submission" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_submission" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@grade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grade" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `result_ID`, `STUDENT_student_ID`, `ASSESSMENT_assessment_ID`, `date_submission`, `grade` FROM `RESULT`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `RESULT` SET `STUDENT_student_ID` = @STUDENT_student_ID, `ASSESSMENT_assessment_ID` = @ASSESSMENT_assessment_ID, `date_submission` = @date_submission, `grade` = @grade WHERE ((`result_ID` = @Original_result_ID) AND (`STUDENT_student_ID` = @Original_STUDENT_student_ID) AND (`ASSESSMENT_assessment_ID` = @Original_ASSESSMENT_assessment_ID) AND (`date_submission` = @Original_date_submission) AND (`grade` = @Original_grade))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ASSESSMENT_assessment_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ASSESSMENT_assessment_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@date_submission" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_submission" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@grade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grade" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_result_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="result_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_STUDENT_student_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="STUDENT_student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ASSESSMENT_assessment_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ASSESSMENT_assessment_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_date_submission" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="date_submission" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_grade" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="grade" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="result_ID" DataSetColumn="result_ID" />
              <Mapping SourceColumn="STUDENT_student_ID" DataSetColumn="STUDENT_student_ID" />
              <Mapping SourceColumn="ASSESSMENT_assessment_ID" DataSetColumn="ASSESSMENT_assessment_ID" />
              <Mapping SourceColumn="date_submission" DataSetColumn="date_submission" />
              <Mapping SourceColumn="grade" DataSetColumn="grade" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ROOMTableAdapter" GeneratorDataComponentClassName="ROOMTableAdapter" Name="ROOM" UserDataComponentName="ROOMTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.ROOM" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ROOM` WHERE ((`room_ID` = @Original_room_ID) AND (`type` = @Original_type) AND (`capacity` = @Original_capacity))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_room_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="room_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_capacity" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="capacity" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ROOM` (`room_ID`, `type`, `capacity`) VALUES (@room_ID, @type, @capacity)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@room_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="room_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@capacity" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="capacity" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `room_ID`, `type`, `capacity` FROM `ROOM`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ROOM` SET `room_ID` = @room_ID, `type` = @type, `capacity` = @capacity WHERE ((`room_ID` = @Original_room_ID) AND (`type` = @Original_type) AND (`capacity` = @Original_capacity))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@room_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="room_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@capacity" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="capacity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_room_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="room_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_capacity" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="capacity" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="room_ID" DataSetColumn="room_ID" />
              <Mapping SourceColumn="type" DataSetColumn="type" />
              <Mapping SourceColumn="capacity" DataSetColumn="capacity" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SLOTTableAdapter" GeneratorDataComponentClassName="SLOTTableAdapter" Name="SLOT" UserDataComponentName="SLOTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.SLOT" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `SLOT` WHERE ((`slot_ID` = @Original_slot_ID) AND (`MODULE_module_Code` = @Original_MODULE_module_Code) AND (`day` = @Original_day) AND (`type_lesson` = @Original_type_lesson) AND (`from` = @Original_from) AND (`to` = @Original_to) AND (`ROOM_room_ID` = @Original_ROOM_room_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_slot_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="slot_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_day" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="day" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_type_lesson" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type_lesson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@Original_from" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="from" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@Original_to" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="to" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROOM_room_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROOM_room_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `SLOT` (`MODULE_module_Code`, `day`, `type_lesson`, `from`, `to`, `ROOM_room_ID`) VALUES (@MODULE_module_Code, @day, @type_lesson, @from, @to, @ROOM_room_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@day" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="day" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type_lesson" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type_lesson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@from" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="from" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@to" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROOM_room_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROOM_room_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `slot_ID`, `MODULE_module_Code`, `day`, `type_lesson`, `from`, `to`, `ROOM_room_ID` FROM `SLOT`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `SLOT` SET `MODULE_module_Code` = @MODULE_module_Code, `day` = @day, `type_lesson` = @type_lesson, `from` = @from, `to` = @to, `ROOM_room_ID` = @ROOM_room_ID WHERE ((`slot_ID` = @Original_slot_ID) AND (`MODULE_module_Code` = @Original_MODULE_module_Code) AND (`day` = @Original_day) AND (`type_lesson` = @Original_type_lesson) AND (`from` = @Original_from) AND (`to` = @Original_to) AND (`ROOM_room_ID` = @Original_ROOM_room_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@day" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="day" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@type_lesson" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type_lesson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@from" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="from" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@to" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ROOM_room_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROOM_room_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_slot_ID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="slot_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MODULE_module_Code" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MODULE_module_Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_day" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="day" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_type_lesson" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="type_lesson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@Original_from" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="from" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Time" Direction="Input" ParameterName="@Original_to" Precision="0" ProviderType="Time" Scale="0" Size="0" SourceColumn="to" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ROOM_room_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ROOM_room_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="slot_ID" DataSetColumn="slot_ID" />
              <Mapping SourceColumn="MODULE_module_Code" DataSetColumn="MODULE_module_Code" />
              <Mapping SourceColumn="day" DataSetColumn="day" />
              <Mapping SourceColumn="type_lesson" DataSetColumn="type_lesson" />
              <Mapping SourceColumn="from" DataSetColumn="from" />
              <Mapping SourceColumn="to" DataSetColumn="to" />
              <Mapping SourceColumn="ROOM_room_ID" DataSetColumn="ROOM_room_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="STAFFTableAdapter" GeneratorDataComponentClassName="STAFFTableAdapter" Name="STAFF" UserDataComponentName="STAFFTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.STAFF" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `STAFF` WHERE ((`staff_ID` = @Original_staff_ID) AND (`name` = @Original_name) AND ((@IsNull_middle_name = 1 AND `middle_name` IS NULL) OR (`middle_name` = @Original_middle_name)) AND (`surname` = @Original_surname) AND (`DOB` = @Original_DOB) AND (`nationality` = @Original_nationality) AND (`home_town` = @Original_home_town) AND ((@IsNull_street_address = 1 AND `street_address` IS NULL) OR (`street_address` = @Original_street_address)) AND (`postcode` = @Original_postcode) AND (`city` = @Original_city) AND (`mobile_number` = @Original_mobile_number) AND (`telephone_number` = @Original_telephone_number) AND (`email_address` = @Original_email_address) AND (`role` = @Original_role) AND (`date_employment_from` = @Original_date_employment_from) AND (`date_employment_to` = @Original_date_employment_to) AND (`status` = @Original_status) AND ((@IsNull_reason_dormancy = 1 AND `reason_dormancy` IS NULL) OR (`reason_dormancy` = @Original_reason_dormancy)) AND (`password` = @Original_password))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="staff_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_middle_name" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_surname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DOB" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nationality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_home_town" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="home_town" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_street_address" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="street_address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_street_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="street_address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_postcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="postcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mobile_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="mobile_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telephone_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telephone_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email_address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_role" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_employment_from" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_employment_from" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_employment_to" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_employment_to" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_reason_dormancy" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="reason_dormancy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_reason_dormancy" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reason_dormancy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `STAFF` (`staff_ID`, `name`, `middle_name`, `surname`, `DOB`, `nationality`, `home_town`, `street_address`, `postcode`, `city`, `mobile_number`, `telephone_number`, `email_address`, `role`, `date_employment_from`, `date_employment_to`, `status`, `reason_dormancy`, `password`) VALUES (@staff_ID, @name, @middle_name, @surname, @DOB, @nationality, @home_town, @street_address, @postcode, @city, @mobile_number, @telephone_number, @email_address, @role, @date_employment_from, @date_employment_to, @status, @reason_dormancy, @password)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="staff_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@surname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DOB" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nationality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@home_town" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="home_town" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@street_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="street_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@postcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="postcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mobile_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="mobile_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telephone_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telephone_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@role" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_employment_from" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_employment_from" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_employment_to" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_employment_to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@reason_dormancy" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reason_dormancy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT staff_ID, name, middle_name, surname, DOB, nationality, home_town, street_address, postcode, city, mobile_number, telephone_number, email_address, role, date_employment_from, date_employment_to, status, reason_dormancy, password FROM STAFF</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `STAFF` SET `staff_ID` = @staff_ID, `name` = @name, `middle_name` = @middle_name, `surname` = @surname, `DOB` = @DOB, `nationality` = @nationality, `home_town` = @home_town, `street_address` = @street_address, `postcode` = @postcode, `city` = @city, `mobile_number` = @mobile_number, `telephone_number` = @telephone_number, `email_address` = @email_address, `role` = @role, `date_employment_from` = @date_employment_from, `date_employment_to` = @date_employment_to, `status` = @status, `reason_dormancy` = @reason_dormancy, `password` = @password WHERE ((`staff_ID` = @Original_staff_ID) AND (`name` = @Original_name) AND ((@IsNull_middle_name = 1 AND `middle_name` IS NULL) OR (`middle_name` = @Original_middle_name)) AND (`surname` = @Original_surname) AND (`DOB` = @Original_DOB) AND (`nationality` = @Original_nationality) AND (`home_town` = @Original_home_town) AND ((@IsNull_street_address = 1 AND `street_address` IS NULL) OR (`street_address` = @Original_street_address)) AND (`postcode` = @Original_postcode) AND (`city` = @Original_city) AND (`mobile_number` = @Original_mobile_number) AND (`telephone_number` = @Original_telephone_number) AND (`email_address` = @Original_email_address) AND (`role` = @Original_role) AND (`date_employment_from` = @Original_date_employment_from) AND (`date_employment_to` = @Original_date_employment_to) AND (`status` = @Original_status) AND ((@IsNull_reason_dormancy = 1 AND `reason_dormancy` IS NULL) OR (`reason_dormancy` = @Original_reason_dormancy)) AND (`password` = @Original_password))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="staff_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@surname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="surname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@DOB" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nationality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@home_town" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="home_town" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@street_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="street_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@postcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="postcode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mobile_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="mobile_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telephone_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telephone_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@role" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_employment_from" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_employment_from" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_employment_to" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_employment_to" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@reason_dormancy" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reason_dormancy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_staff_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="staff_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_middle_name" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_middle_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="middle_name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_surname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="surname" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_DOB" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DOB" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nationality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_home_town" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="home_town" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_street_address" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="street_address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_street_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="street_address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_postcode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="postcode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_city" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="city" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mobile_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="mobile_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telephone_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="telephone_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_email_address" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="email_address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_role" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="role" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_employment_from" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_employment_from" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_date_employment_to" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_employment_to" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_reason_dormancy" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="reason_dormancy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_reason_dormancy" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reason_dormancy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="staff_ID" DataSetColumn="staff_ID" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="middle_name" DataSetColumn="middle_name" />
              <Mapping SourceColumn="surname" DataSetColumn="surname" />
              <Mapping SourceColumn="DOB" DataSetColumn="DOB" />
              <Mapping SourceColumn="nationality" DataSetColumn="nationality" />
              <Mapping SourceColumn="home_town" DataSetColumn="home_town" />
              <Mapping SourceColumn="street_address" DataSetColumn="street_address" />
              <Mapping SourceColumn="postcode" DataSetColumn="postcode" />
              <Mapping SourceColumn="city" DataSetColumn="city" />
              <Mapping SourceColumn="mobile_number" DataSetColumn="mobile_number" />
              <Mapping SourceColumn="telephone_number" DataSetColumn="telephone_number" />
              <Mapping SourceColumn="email_address" DataSetColumn="email_address" />
              <Mapping SourceColumn="role" DataSetColumn="role" />
              <Mapping SourceColumn="date_employment_from" DataSetColumn="date_employment_from" />
              <Mapping SourceColumn="date_employment_to" DataSetColumn="date_employment_to" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="reason_dormancy" DataSetColumn="reason_dormancy" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WEEKTableAdapter" GeneratorDataComponentClassName="WEEKTableAdapter" Name="WEEK" UserDataComponentName="WEEKTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.WEEK" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `WEEK` WHERE ((`id_Week` = @Original_id_Week) AND (`day` = @Original_day) AND (`week_number` = @Original_week_number))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_Week" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id_Week" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_day" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="day" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_week_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="week_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `WEEK` (`day`, `week_number`) VALUES (@day, @week_number)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@day" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="day" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@week_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="week_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `id_Week`, `day`, `week_number` FROM `WEEK`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `WEEK` SET `day` = @day, `week_number` = @week_number WHERE ((`id_Week` = @Original_id_Week) AND (`day` = @Original_day) AND (`week_number` = @Original_week_number))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@day" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="day" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@week_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="week_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id_Week" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="id_Week" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_day" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="day" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_week_number" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="week_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id_Week" DataSetColumn="id_Week" />
              <Mapping SourceColumn="day" DataSetColumn="day" />
              <Mapping SourceColumn="week_number" DataSetColumn="week_number" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PERSONTableAdapter" GeneratorDataComponentClassName="PERSONTableAdapter" Name="PERSON" UserDataComponentName="PERSONTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.PERSON" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `ID`, `person_name`, `person_surname` FROM `alpha_db`.`PERSON`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="person_name" DataSetColumn="person_name" />
              <Mapping SourceColumn="person_surname" DataSetColumn="person_surname" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="EVENT_VIEWTableAdapter" GeneratorDataComponentClassName="EVENT_VIEWTableAdapter" Name="EVENT_VIEW" UserDataComponentName="EVENT_VIEWTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.EVENT_VIEW" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `event_ID`, `name`, `description`, `date`, `time`, `priority`, `STUDENT_student_ID`, `STAFF_staff_ID` FROM `alpha_db`.`EVENT_VIEW`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="event_ID" DataSetColumn="event_ID" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="date" DataSetColumn="date" />
              <Mapping SourceColumn="time" DataSetColumn="time" />
              <Mapping SourceColumn="priority" DataSetColumn="priority" />
              <Mapping SourceColumn="STUDENT_student_ID" DataSetColumn="STUDENT_student_ID" />
              <Mapping SourceColumn="STAFF_staff_ID" DataSetColumn="STAFF_staff_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="STUDENT_GRADETableAdapter" GeneratorDataComponentClassName="STUDENT_GRADETableAdapter" Name="STUDENT_GRADE" UserDataComponentName="STUDENT_GRADETableAdapter">
            <MainSource>
              <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.STUDENT_GRADE" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT `student_ID`, `name`, `surname`, `weighting_percentage`, `grade`, `date_submission`, `module_Code`, `module_Title`, `course_Title` FROM `alpha_db`.`STUDENT_GRADE`</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="student_ID" DataSetColumn="student_ID" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="surname" DataSetColumn="surname" />
              <Mapping SourceColumn="weighting_percentage" DataSetColumn="weighting_percentage" />
              <Mapping SourceColumn="grade" DataSetColumn="grade" />
              <Mapping SourceColumn="date_submission" DataSetColumn="date_submission" />
              <Mapping SourceColumn="module_Code" DataSetColumn="module_Code" />
              <Mapping SourceColumn="module_Title" DataSetColumn="module_Title" />
              <Mapping SourceColumn="course_Title" DataSetColumn="course_Title" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="alpha_dbConnectionString (Settings)" DbObjectName="alpha_db.EVENT" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="sqlFetchEvents" MethodsParameterType="CLR" Modifier="Public" Name="sqlFetchEvents" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="sqlFetchEvents">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>SELECT        name, description, `date`, `time`, priority, STUDENT_student_ID, STAFF_staff_ID
FROM            EVENT</CommandText>
                <Parameters />
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="alpha_dbStudentDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="alpha_dbStudentDataSet" msprop:Generator_UserDSName="alpha_dbStudentDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="STUDENT" msprop:Generator_TableClassName="STUDENTDataTable" msprop:Generator_TableVarName="tableSTUDENT" msprop:Generator_TablePropName="STUDENT" msprop:Generator_RowDeletingName="STUDENTRowDeleting" msprop:Generator_RowChangingName="STUDENTRowChanging" msprop:Generator_RowEvHandlerName="STUDENTRowChangeEventHandler" msprop:Generator_RowDeletedName="STUDENTRowDeleted" msprop:Generator_UserTableName="STUDENT" msprop:Generator_RowChangedName="STUDENTRowChanged" msprop:Generator_RowEvArgName="STUDENTRowChangeEvent" msprop:Generator_RowClassName="STUDENTRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="student_ID" msprop:Generator_ColumnVarNameInTable="columnstudent_ID" msprop:Generator_ColumnPropNameInRow="student_ID" msprop:Generator_ColumnPropNameInTable="student_IDColumn" msprop:Generator_UserColumnName="student_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COURSE_course_Code" msprop:Generator_ColumnVarNameInTable="columnCOURSE_course_Code" msprop:Generator_ColumnPropNameInRow="COURSE_course_Code" msprop:Generator_ColumnPropNameInTable="COURSE_course_CodeColumn" msprop:Generator_UserColumnName="COURSE_course_Code" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="level" msprop:Generator_ColumnVarNameInTable="columnlevel" msprop:Generator_ColumnPropNameInRow="level" msprop:Generator_ColumnPropNameInTable="levelColumn" msprop:Generator_UserColumnName="level" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="middle_name" msprop:Generator_ColumnVarNameInTable="columnmiddle_name" msprop:Generator_ColumnPropNameInRow="middle_name" msprop:Generator_ColumnPropNameInTable="middle_nameColumn" msprop:Generator_UserColumnName="middle_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="surname" msprop:Generator_ColumnVarNameInTable="columnsurname" msprop:Generator_ColumnPropNameInRow="surname" msprop:Generator_ColumnPropNameInTable="surnameColumn" msprop:Generator_UserColumnName="surname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOB" msprop:Generator_ColumnVarNameInTable="columnDOB" msprop:Generator_ColumnPropNameInRow="DOB" msprop:Generator_ColumnPropNameInTable="DOBColumn" msprop:Generator_UserColumnName="DOB" type="xs:dateTime" />
              <xs:element name="nationality" msprop:Generator_ColumnVarNameInTable="columnnationality" msprop:Generator_ColumnPropNameInRow="nationality" msprop:Generator_ColumnPropNameInTable="nationalityColumn" msprop:Generator_UserColumnName="nationality">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="home_town" msprop:Generator_ColumnVarNameInTable="columnhome_town" msprop:Generator_ColumnPropNameInRow="home_town" msprop:Generator_ColumnPropNameInTable="home_townColumn" msprop:Generator_UserColumnName="home_town">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="street_address" msprop:Generator_ColumnVarNameInTable="columnstreet_address" msprop:Generator_ColumnPropNameInRow="street_address" msprop:Generator_ColumnPropNameInTable="street_addressColumn" msprop:Generator_UserColumnName="street_address">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="postcode" msprop:Generator_ColumnVarNameInTable="columnpostcode" msprop:Generator_ColumnPropNameInRow="postcode" msprop:Generator_ColumnPropNameInTable="postcodeColumn" msprop:Generator_UserColumnName="postcode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="city" msprop:Generator_ColumnVarNameInTable="columncity" msprop:Generator_ColumnPropNameInRow="city" msprop:Generator_ColumnPropNameInTable="cityColumn" msprop:Generator_UserColumnName="city">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mobile_number" msprop:Generator_ColumnVarNameInTable="columnmobile_number" msprop:Generator_ColumnPropNameInRow="mobile_number" msprop:Generator_ColumnPropNameInTable="mobile_numberColumn" msprop:Generator_UserColumnName="mobile_number" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telephone_number" msprop:Generator_ColumnVarNameInTable="columntelephone_number" msprop:Generator_ColumnPropNameInRow="telephone_number" msprop:Generator_ColumnPropNameInTable="telephone_numberColumn" msprop:Generator_UserColumnName="telephone_number" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_enrolment" msprop:Generator_ColumnVarNameInTable="columndate_enrolment" msprop:Generator_ColumnPropNameInRow="date_enrolment" msprop:Generator_ColumnPropNameInTable="date_enrolmentColumn" msprop:Generator_UserColumnName="date_enrolment" type="xs:dateTime" />
              <xs:element name="date_graduation" msprop:Generator_ColumnVarNameInTable="columndate_graduation" msprop:Generator_ColumnPropNameInRow="date_graduation" msprop:Generator_ColumnPropNameInTable="date_graduationColumn" msprop:Generator_UserColumnName="date_graduation" type="xs:dateTime" />
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email_address" msprop:Generator_ColumnVarNameInTable="columnemail_address" msprop:Generator_ColumnPropNameInRow="email_address" msprop:Generator_ColumnPropNameInTable="email_addressColumn" msprop:Generator_UserColumnName="email_address">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="image_location" msprop:Generator_ColumnVarNameInTable="columnimage_location" msprop:Generator_ColumnPropNameInRow="image_location" msprop:Generator_ColumnPropNameInTable="image_locationColumn" msprop:Generator_UserColumnName="image_location" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="assigned_email" msprop:Generator_ColumnVarNameInTable="columnassigned_email" msprop:Generator_ColumnPropNameInRow="assigned_email" msprop:Generator_ColumnPropNameInTable="assigned_emailColumn" msprop:Generator_UserColumnName="assigned_email">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ASSESSMENT" msprop:Generator_TableClassName="ASSESSMENTDataTable" msprop:Generator_TableVarName="tableASSESSMENT" msprop:Generator_RowChangedName="ASSESSMENTRowChanged" msprop:Generator_TablePropName="ASSESSMENT" msprop:Generator_RowDeletingName="ASSESSMENTRowDeleting" msprop:Generator_RowChangingName="ASSESSMENTRowChanging" msprop:Generator_RowEvHandlerName="ASSESSMENTRowChangeEventHandler" msprop:Generator_RowDeletedName="ASSESSMENTRowDeleted" msprop:Generator_RowClassName="ASSESSMENTRow" msprop:Generator_UserTableName="ASSESSMENT" msprop:Generator_RowEvArgName="ASSESSMENTRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="assessment_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnassessment_ID" msprop:Generator_ColumnPropNameInRow="assessment_ID" msprop:Generator_ColumnPropNameInTable="assessment_IDColumn" msprop:Generator_UserColumnName="assessment_ID" type="xs:int" />
              <xs:element name="MODULE_module_Code" msprop:Generator_ColumnVarNameInTable="columnMODULE_module_Code" msprop:Generator_ColumnPropNameInRow="MODULE_module_Code" msprop:Generator_ColumnPropNameInTable="MODULE_module_CodeColumn" msprop:Generator_UserColumnName="MODULE_module_Code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hand_out_date" msprop:Generator_ColumnVarNameInTable="columnhand_out_date" msprop:Generator_ColumnPropNameInRow="hand_out_date" msprop:Generator_ColumnPropNameInTable="hand_out_dateColumn" msprop:Generator_UserColumnName="hand_out_date" type="xs:dateTime" />
              <xs:element name="due_in_date" msprop:Generator_ColumnVarNameInTable="columndue_in_date" msprop:Generator_ColumnPropNameInRow="due_in_date" msprop:Generator_ColumnPropNameInTable="due_in_dateColumn" msprop:Generator_UserColumnName="due_in_date" type="xs:dateTime" />
              <xs:element name="weighting_percentage" msprop:Generator_ColumnVarNameInTable="columnweighting_percentage" msprop:Generator_ColumnPropNameInRow="weighting_percentage" msprop:Generator_ColumnPropNameInTable="weighting_percentageColumn" msprop:Generator_UserColumnName="weighting_percentage" type="xs:int" />
              <xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ASSIGNED" msprop:Generator_TableClassName="ASSIGNEDDataTable" msprop:Generator_TableVarName="tableASSIGNED" msprop:Generator_RowChangedName="ASSIGNEDRowChanged" msprop:Generator_TablePropName="ASSIGNED" msprop:Generator_RowDeletingName="ASSIGNEDRowDeleting" msprop:Generator_RowChangingName="ASSIGNEDRowChanging" msprop:Generator_RowEvHandlerName="ASSIGNEDRowChangeEventHandler" msprop:Generator_RowDeletedName="ASSIGNEDRowDeleted" msprop:Generator_RowClassName="ASSIGNEDRow" msprop:Generator_UserTableName="ASSIGNED" msprop:Generator_RowEvArgName="ASSIGNEDRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="assigned_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnassigned_ID" msprop:Generator_ColumnPropNameInRow="assigned_ID" msprop:Generator_ColumnPropNameInTable="assigned_IDColumn" msprop:Generator_UserColumnName="assigned_ID" type="xs:int" />
              <xs:element name="SLOT_slot_ID" msprop:Generator_ColumnVarNameInTable="columnSLOT_slot_ID" msprop:Generator_ColumnPropNameInRow="SLOT_slot_ID" msprop:Generator_ColumnPropNameInTable="SLOT_slot_IDColumn" msprop:Generator_UserColumnName="SLOT_slot_ID" type="xs:int" />
              <xs:element name="STUDENT_student_ID" msprop:Generator_ColumnVarNameInTable="columnSTUDENT_student_ID" msprop:Generator_ColumnPropNameInRow="STUDENT_student_ID" msprop:Generator_ColumnPropNameInTable="STUDENT_student_IDColumn" msprop:Generator_UserColumnName="STUDENT_student_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="group_Number" msprop:Generator_ColumnVarNameInTable="columngroup_Number" msprop:Generator_ColumnPropNameInRow="group_Number" msprop:Generator_ColumnPropNameInTable="group_NumberColumn" msprop:Generator_UserColumnName="group_Number" type="xs:int" />
              <xs:element name="MODULE_module_Code" msprop:Generator_ColumnVarNameInTable="columnMODULE_module_Code" msprop:Generator_ColumnPropNameInRow="MODULE_module_Code" msprop:Generator_ColumnPropNameInTable="MODULE_module_CodeColumn" msprop:Generator_UserColumnName="MODULE_module_Code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CONCERN_LETTER" msprop:Generator_TableClassName="CONCERN_LETTERDataTable" msprop:Generator_TableVarName="tableCONCERN_LETTER" msprop:Generator_RowChangedName="CONCERN_LETTERRowChanged" msprop:Generator_TablePropName="CONCERN_LETTER" msprop:Generator_RowDeletingName="CONCERN_LETTERRowDeleting" msprop:Generator_RowChangingName="CONCERN_LETTERRowChanging" msprop:Generator_RowEvHandlerName="CONCERN_LETTERRowChangeEventHandler" msprop:Generator_RowDeletedName="CONCERN_LETTERRowDeleted" msprop:Generator_RowClassName="CONCERN_LETTERRow" msprop:Generator_UserTableName="CONCERN_LETTER" msprop:Generator_RowEvArgName="CONCERN_LETTERRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="letter_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnletter_ID" msprop:Generator_ColumnPropNameInRow="letter_ID" msprop:Generator_ColumnPropNameInTable="letter_IDColumn" msprop:Generator_UserColumnName="letter_ID" type="xs:int" />
              <xs:element name="STUDENT_student_ID" msprop:Generator_ColumnVarNameInTable="columnSTUDENT_student_ID" msprop:Generator_ColumnPropNameInRow="STUDENT_student_ID" msprop:Generator_ColumnPropNameInTable="STUDENT_student_IDColumn" msprop:Generator_UserColumnName="STUDENT_student_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="motivation" msprop:Generator_ColumnVarNameInTable="columnmotivation" msprop:Generator_ColumnPropNameInRow="motivation" msprop:Generator_ColumnPropNameInTable="motivationColumn" msprop:Generator_UserColumnName="motivation">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_sent" msprop:Generator_ColumnVarNameInTable="columndate_sent" msprop:Generator_ColumnPropNameInRow="date_sent" msprop:Generator_ColumnPropNameInTable="date_sentColumn" msprop:Generator_UserColumnName="date_sent" type="xs:dateTime" />
              <xs:element name="contact_due_date" msprop:Generator_ColumnVarNameInTable="columncontact_due_date" msprop:Generator_ColumnPropNameInRow="contact_due_date" msprop:Generator_ColumnPropNameInTable="contact_due_dateColumn" msprop:Generator_UserColumnName="contact_due_date" type="xs:dateTime" />
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="COURSE" msprop:Generator_TableClassName="COURSEDataTable" msprop:Generator_TableVarName="tableCOURSE" msprop:Generator_RowChangedName="COURSERowChanged" msprop:Generator_TablePropName="COURSE" msprop:Generator_RowDeletingName="COURSERowDeleting" msprop:Generator_RowChangingName="COURSERowChanging" msprop:Generator_RowEvHandlerName="COURSERowChangeEventHandler" msprop:Generator_RowDeletedName="COURSERowDeleted" msprop:Generator_RowClassName="COURSERow" msprop:Generator_UserTableName="COURSE" msprop:Generator_RowEvArgName="COURSERowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="course_Code" msprop:Generator_ColumnVarNameInTable="columncourse_Code" msprop:Generator_ColumnPropNameInRow="course_Code" msprop:Generator_ColumnPropNameInTable="course_CodeColumn" msprop:Generator_UserColumnName="course_Code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="year" msprop:Generator_ColumnVarNameInTable="columnyear" msprop:Generator_ColumnPropNameInRow="year" msprop:Generator_ColumnPropNameInTable="yearColumn" msprop:Generator_UserColumnName="year" type="xs:int" />
              <xs:element name="department" msprop:Generator_ColumnVarNameInTable="columndepartment" msprop:Generator_ColumnPropNameInRow="department" msprop:Generator_ColumnPropNameInTable="departmentColumn" msprop:Generator_UserColumnName="department">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="max_students" msprop:Generator_ColumnVarNameInTable="columnmax_students" msprop:Generator_ColumnPropNameInRow="max_students" msprop:Generator_ColumnPropNameInTable="max_studentsColumn" msprop:Generator_UserColumnName="max_students" type="xs:int" />
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="requirements" msprop:Generator_ColumnVarNameInTable="columnrequirements" msprop:Generator_ColumnPropNameInRow="requirements" msprop:Generator_ColumnPropNameInTable="requirementsColumn" msprop:Generator_UserColumnName="requirements">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EVENT" msprop:Generator_TableClassName="EVENTDataTable" msprop:Generator_TableVarName="tableEVENT" msprop:Generator_RowChangedName="EVENTRowChanged" msprop:Generator_TablePropName="EVENT" msprop:Generator_RowDeletingName="EVENTRowDeleting" msprop:Generator_RowChangingName="EVENTRowChanging" msprop:Generator_RowEvHandlerName="EVENTRowChangeEventHandler" msprop:Generator_RowDeletedName="EVENTRowDeleted" msprop:Generator_RowClassName="EVENTRow" msprop:Generator_UserTableName="EVENT" msprop:Generator_RowEvArgName="EVENTRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="event_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnevent_ID" msprop:Generator_ColumnPropNameInRow="event_ID" msprop:Generator_ColumnPropNameInTable="event_IDColumn" msprop:Generator_UserColumnName="event_ID" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_UserColumnName="date" type="xs:dateTime" />
              <xs:element name="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" msprop:Generator_UserColumnName="time" type="xs:duration" />
              <xs:element name="priority" msprop:Generator_ColumnVarNameInTable="columnpriority" msprop:Generator_ColumnPropNameInRow="priority" msprop:Generator_ColumnPropNameInTable="priorityColumn" msprop:Generator_UserColumnName="priority">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="STUDENT_student_ID" msprop:Generator_ColumnVarNameInTable="columnSTUDENT_student_ID" msprop:Generator_ColumnPropNameInRow="STUDENT_student_ID" msprop:Generator_ColumnPropNameInTable="STUDENT_student_IDColumn" msprop:Generator_UserColumnName="STUDENT_student_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="STAFF_staff_ID" msprop:Generator_ColumnVarNameInTable="columnSTAFF_staff_ID" msprop:Generator_ColumnPropNameInRow="STAFF_staff_ID" msprop:Generator_ColumnPropNameInTable="STAFF_staff_IDColumn" msprop:Generator_UserColumnName="STAFF_staff_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MODULE" msprop:Generator_TableClassName="MODULEDataTable" msprop:Generator_TableVarName="tableMODULE" msprop:Generator_RowChangedName="MODULERowChanged" msprop:Generator_TablePropName="MODULE" msprop:Generator_RowDeletingName="MODULERowDeleting" msprop:Generator_RowChangingName="MODULERowChanging" msprop:Generator_RowEvHandlerName="MODULERowChangeEventHandler" msprop:Generator_RowDeletedName="MODULERowDeleted" msprop:Generator_RowClassName="MODULERow" msprop:Generator_UserTableName="MODULE" msprop:Generator_RowEvArgName="MODULERowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="module_Code" msprop:Generator_ColumnVarNameInTable="columnmodule_Code" msprop:Generator_ColumnPropNameInRow="module_Code" msprop:Generator_ColumnPropNameInTable="module_CodeColumn" msprop:Generator_UserColumnName="module_Code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="COURSE_course_Code" msprop:Generator_ColumnVarNameInTable="columnCOURSE_course_Code" msprop:Generator_ColumnPropNameInRow="COURSE_course_Code" msprop:Generator_ColumnPropNameInTable="COURSE_course_CodeColumn" msprop:Generator_UserColumnName="COURSE_course_Code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="field" msprop:Generator_ColumnVarNameInTable="columnfield" msprop:Generator_ColumnPropNameInRow="field" msprop:Generator_ColumnPropNameInTable="fieldColumn" msprop:Generator_UserColumnName="field">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="credits" msprop:Generator_ColumnVarNameInTable="columncredits" msprop:Generator_ColumnPropNameInRow="credits" msprop:Generator_ColumnPropNameInTable="creditsColumn" msprop:Generator_UserColumnName="credits" type="xs:int" />
              <xs:element name="STAFF_staff_ID" msprop:Generator_ColumnVarNameInTable="columnSTAFF_staff_ID" msprop:Generator_ColumnPropNameInRow="STAFF_staff_ID" msprop:Generator_ColumnPropNameInTable="STAFF_staff_IDColumn" msprop:Generator_UserColumnName="STAFF_staff_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="level" msprop:Generator_ColumnVarNameInTable="columnlevel" msprop:Generator_ColumnPropNameInRow="level" msprop:Generator_ColumnPropNameInTable="levelColumn" msprop:Generator_UserColumnName="level" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PERSONAL_TUTORIAL" msprop:Generator_TableClassName="PERSONAL_TUTORIALDataTable" msprop:Generator_TableVarName="tablePERSONAL_TUTORIAL" msprop:Generator_RowChangedName="PERSONAL_TUTORIALRowChanged" msprop:Generator_TablePropName="PERSONAL_TUTORIAL" msprop:Generator_RowDeletingName="PERSONAL_TUTORIALRowDeleting" msprop:Generator_RowChangingName="PERSONAL_TUTORIALRowChanging" msprop:Generator_RowEvHandlerName="PERSONAL_TUTORIALRowChangeEventHandler" msprop:Generator_RowDeletedName="PERSONAL_TUTORIALRowDeleted" msprop:Generator_RowClassName="PERSONAL_TUTORIALRow" msprop:Generator_UserTableName="PERSONAL_TUTORIAL" msprop:Generator_RowEvArgName="PERSONAL_TUTORIALRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="pt_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnpt_ID" msprop:Generator_ColumnPropNameInRow="pt_ID" msprop:Generator_ColumnPropNameInTable="pt_IDColumn" msprop:Generator_UserColumnName="pt_ID" type="xs:int" />
              <xs:element name="STUDENT_student_ID" msprop:Generator_ColumnVarNameInTable="columnSTUDENT_student_ID" msprop:Generator_ColumnPropNameInRow="STUDENT_student_ID" msprop:Generator_ColumnPropNameInTable="STUDENT_student_IDColumn" msprop:Generator_UserColumnName="STUDENT_student_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="STAFF_staff_ID" msprop:Generator_ColumnVarNameInTable="columnSTAFF_staff_ID" msprop:Generator_ColumnPropNameInRow="STAFF_staff_ID" msprop:Generator_ColumnPropNameInTable="STAFF_staff_IDColumn" msprop:Generator_UserColumnName="STAFF_staff_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="term" msprop:Generator_ColumnVarNameInTable="columnterm" msprop:Generator_ColumnPropNameInRow="term" msprop:Generator_ColumnPropNameInTable="termColumn" msprop:Generator_UserColumnName="term" type="xs:int" />
              <xs:element name="date_time" msprop:Generator_ColumnVarNameInTable="columndate_time" msprop:Generator_ColumnPropNameInRow="date_time" msprop:Generator_ColumnPropNameInTable="date_timeColumn" msprop:Generator_UserColumnName="date_time" type="xs:dateTime" />
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="QUALIFICATION" msprop:Generator_TableClassName="QUALIFICATIONDataTable" msprop:Generator_TableVarName="tableQUALIFICATION" msprop:Generator_RowChangedName="QUALIFICATIONRowChanged" msprop:Generator_TablePropName="QUALIFICATION" msprop:Generator_RowDeletingName="QUALIFICATIONRowDeleting" msprop:Generator_RowChangingName="QUALIFICATIONRowChanging" msprop:Generator_RowEvHandlerName="QUALIFICATIONRowChangeEventHandler" msprop:Generator_RowDeletedName="QUALIFICATIONRowDeleted" msprop:Generator_RowClassName="QUALIFICATIONRow" msprop:Generator_UserTableName="QUALIFICATION" msprop:Generator_RowEvArgName="QUALIFICATIONRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id_Qualification" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid_Qualification" msprop:Generator_ColumnPropNameInRow="id_Qualification" msprop:Generator_ColumnPropNameInTable="id_QualificationColumn" msprop:Generator_UserColumnName="id_Qualification" type="xs:int" />
              <xs:element name="STUDENT_student_ID" msprop:Generator_ColumnVarNameInTable="columnSTUDENT_student_ID" msprop:Generator_ColumnPropNameInRow="STUDENT_student_ID" msprop:Generator_ColumnPropNameInTable="STUDENT_student_IDColumn" msprop:Generator_UserColumnName="STUDENT_student_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="subject" msprop:Generator_ColumnVarNameInTable="columnsubject" msprop:Generator_ColumnPropNameInRow="subject" msprop:Generator_ColumnPropNameInTable="subjectColumn" msprop:Generator_UserColumnName="subject">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="grade" msprop:Generator_ColumnVarNameInTable="columngrade" msprop:Generator_ColumnPropNameInRow="grade" msprop:Generator_ColumnPropNameInTable="gradeColumn" msprop:Generator_UserColumnName="grade">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_achieved" msprop:Generator_ColumnVarNameInTable="columndate_achieved" msprop:Generator_ColumnPropNameInRow="date_achieved" msprop:Generator_ColumnPropNameInTable="date_achievedColumn" msprop:Generator_UserColumnName="date_achieved" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="REGISTER" msprop:Generator_TableClassName="REGISTERDataTable" msprop:Generator_TableVarName="tableREGISTER" msprop:Generator_RowChangedName="REGISTERRowChanged" msprop:Generator_TablePropName="REGISTER" msprop:Generator_RowDeletingName="REGISTERRowDeleting" msprop:Generator_RowChangingName="REGISTERRowChanging" msprop:Generator_RowEvHandlerName="REGISTERRowChangeEventHandler" msprop:Generator_RowDeletedName="REGISTERRowDeleted" msprop:Generator_RowClassName="REGISTERRow" msprop:Generator_UserTableName="REGISTER" msprop:Generator_RowEvArgName="REGISTERRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="register_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnregister_ID" msprop:Generator_ColumnPropNameInRow="register_ID" msprop:Generator_ColumnPropNameInTable="register_IDColumn" msprop:Generator_UserColumnName="register_ID" type="xs:int" />
              <xs:element name="MODULE_module_Code" msprop:Generator_ColumnVarNameInTable="columnMODULE_module_Code" msprop:Generator_ColumnPropNameInRow="MODULE_module_Code" msprop:Generator_ColumnPropNameInTable="MODULE_module_CodeColumn" msprop:Generator_UserColumnName="MODULE_module_Code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_creation" msprop:Generator_ColumnVarNameInTable="columndate_creation" msprop:Generator_ColumnPropNameInRow="date_creation" msprop:Generator_ColumnPropNameInTable="date_creationColumn" msprop:Generator_UserColumnName="date_creation" type="xs:dateTime" />
              <xs:element name="attendance" msprop:Generator_ColumnVarNameInTable="columnattendance" msprop:Generator_ColumnPropNameInRow="attendance" msprop:Generator_ColumnPropNameInTable="attendanceColumn" msprop:Generator_UserColumnName="attendance" type="xs:int" />
              <xs:element name="WEEK_id_Week" msprop:Generator_ColumnVarNameInTable="columnWEEK_id_Week" msprop:Generator_ColumnPropNameInRow="WEEK_id_Week" msprop:Generator_ColumnPropNameInTable="WEEK_id_WeekColumn" msprop:Generator_UserColumnName="WEEK_id_Week" type="xs:int" />
              <xs:element name="STUDENT_student_ID" msprop:Generator_ColumnVarNameInTable="columnSTUDENT_student_ID" msprop:Generator_ColumnPropNameInRow="STUDENT_student_ID" msprop:Generator_ColumnPropNameInTable="STUDENT_student_IDColumn" msprop:Generator_UserColumnName="STUDENT_student_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RESULT" msprop:Generator_TableClassName="RESULTDataTable" msprop:Generator_TableVarName="tableRESULT" msprop:Generator_RowChangedName="RESULTRowChanged" msprop:Generator_TablePropName="RESULT" msprop:Generator_RowDeletingName="RESULTRowDeleting" msprop:Generator_RowChangingName="RESULTRowChanging" msprop:Generator_RowEvHandlerName="RESULTRowChangeEventHandler" msprop:Generator_RowDeletedName="RESULTRowDeleted" msprop:Generator_RowClassName="RESULTRow" msprop:Generator_UserTableName="RESULT" msprop:Generator_RowEvArgName="RESULTRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="result_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnresult_ID" msprop:Generator_ColumnPropNameInRow="result_ID" msprop:Generator_ColumnPropNameInTable="result_IDColumn" msprop:Generator_UserColumnName="result_ID" type="xs:int" />
              <xs:element name="STUDENT_student_ID" msprop:Generator_ColumnVarNameInTable="columnSTUDENT_student_ID" msprop:Generator_ColumnPropNameInRow="STUDENT_student_ID" msprop:Generator_ColumnPropNameInTable="STUDENT_student_IDColumn" msprop:Generator_UserColumnName="STUDENT_student_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ASSESSMENT_assessment_ID" msprop:Generator_ColumnVarNameInTable="columnASSESSMENT_assessment_ID" msprop:Generator_ColumnPropNameInRow="ASSESSMENT_assessment_ID" msprop:Generator_ColumnPropNameInTable="ASSESSMENT_assessment_IDColumn" msprop:Generator_UserColumnName="ASSESSMENT_assessment_ID" type="xs:int" />
              <xs:element name="date_submission" msprop:Generator_ColumnVarNameInTable="columndate_submission" msprop:Generator_ColumnPropNameInRow="date_submission" msprop:Generator_ColumnPropNameInTable="date_submissionColumn" msprop:Generator_UserColumnName="date_submission" type="xs:dateTime" />
              <xs:element name="grade" msprop:Generator_ColumnVarNameInTable="columngrade" msprop:Generator_ColumnPropNameInRow="grade" msprop:Generator_ColumnPropNameInTable="gradeColumn" msprop:Generator_UserColumnName="grade">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ROOM" msprop:Generator_TableClassName="ROOMDataTable" msprop:Generator_TableVarName="tableROOM" msprop:Generator_RowChangedName="ROOMRowChanged" msprop:Generator_TablePropName="ROOM" msprop:Generator_RowDeletingName="ROOMRowDeleting" msprop:Generator_RowChangingName="ROOMRowChanging" msprop:Generator_RowEvHandlerName="ROOMRowChangeEventHandler" msprop:Generator_RowDeletedName="ROOMRowDeleted" msprop:Generator_RowClassName="ROOMRow" msprop:Generator_UserTableName="ROOM" msprop:Generator_RowEvArgName="ROOMRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="room_ID" msprop:Generator_ColumnVarNameInTable="columnroom_ID" msprop:Generator_ColumnPropNameInRow="room_ID" msprop:Generator_ColumnPropNameInTable="room_IDColumn" msprop:Generator_UserColumnName="room_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="capacity" msprop:Generator_ColumnVarNameInTable="columncapacity" msprop:Generator_ColumnPropNameInRow="capacity" msprop:Generator_ColumnPropNameInTable="capacityColumn" msprop:Generator_UserColumnName="capacity" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SLOT" msprop:Generator_TableClassName="SLOTDataTable" msprop:Generator_TableVarName="tableSLOT" msprop:Generator_RowChangedName="SLOTRowChanged" msprop:Generator_TablePropName="SLOT" msprop:Generator_RowDeletingName="SLOTRowDeleting" msprop:Generator_RowChangingName="SLOTRowChanging" msprop:Generator_RowEvHandlerName="SLOTRowChangeEventHandler" msprop:Generator_RowDeletedName="SLOTRowDeleted" msprop:Generator_RowClassName="SLOTRow" msprop:Generator_UserTableName="SLOT" msprop:Generator_RowEvArgName="SLOTRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="slot_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnslot_ID" msprop:Generator_ColumnPropNameInRow="slot_ID" msprop:Generator_ColumnPropNameInTable="slot_IDColumn" msprop:Generator_UserColumnName="slot_ID" type="xs:int" />
              <xs:element name="MODULE_module_Code" msprop:Generator_ColumnVarNameInTable="columnMODULE_module_Code" msprop:Generator_ColumnPropNameInRow="MODULE_module_Code" msprop:Generator_ColumnPropNameInTable="MODULE_module_CodeColumn" msprop:Generator_UserColumnName="MODULE_module_Code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="day" msprop:Generator_ColumnVarNameInTable="columnday" msprop:Generator_ColumnPropNameInRow="day" msprop:Generator_ColumnPropNameInTable="dayColumn" msprop:Generator_UserColumnName="day">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="type_lesson" msprop:Generator_ColumnVarNameInTable="columntype_lesson" msprop:Generator_ColumnPropNameInRow="type_lesson" msprop:Generator_ColumnPropNameInTable="type_lessonColumn" msprop:Generator_UserColumnName="type_lesson">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="from" msprop:Generator_ColumnVarNameInTable="columnfrom" msprop:Generator_ColumnPropNameInRow="from" msprop:Generator_ColumnPropNameInTable="fromColumn" msprop:Generator_UserColumnName="from" type="xs:duration" />
              <xs:element name="to" msprop:Generator_ColumnVarNameInTable="columnto" msprop:Generator_ColumnPropNameInRow="to" msprop:Generator_ColumnPropNameInTable="toColumn" msprop:Generator_UserColumnName="to" type="xs:duration" />
              <xs:element name="ROOM_room_ID" msprop:Generator_ColumnVarNameInTable="columnROOM_room_ID" msprop:Generator_ColumnPropNameInRow="ROOM_room_ID" msprop:Generator_ColumnPropNameInTable="ROOM_room_IDColumn" msprop:Generator_UserColumnName="ROOM_room_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="STAFF" msprop:Generator_TableClassName="STAFFDataTable" msprop:Generator_TableVarName="tableSTAFF" msprop:Generator_RowChangedName="STAFFRowChanged" msprop:Generator_TablePropName="STAFF" msprop:Generator_RowDeletingName="STAFFRowDeleting" msprop:Generator_RowChangingName="STAFFRowChanging" msprop:Generator_RowEvHandlerName="STAFFRowChangeEventHandler" msprop:Generator_RowDeletedName="STAFFRowDeleted" msprop:Generator_RowClassName="STAFFRow" msprop:Generator_UserTableName="STAFF" msprop:Generator_RowEvArgName="STAFFRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="staff_ID" msprop:Generator_ColumnVarNameInTable="columnstaff_ID" msprop:Generator_ColumnPropNameInRow="staff_ID" msprop:Generator_ColumnPropNameInTable="staff_IDColumn" msprop:Generator_UserColumnName="staff_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="middle_name" msprop:Generator_ColumnVarNameInTable="columnmiddle_name" msprop:Generator_ColumnPropNameInRow="middle_name" msprop:Generator_ColumnPropNameInTable="middle_nameColumn" msprop:Generator_UserColumnName="middle_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="surname" msprop:Generator_ColumnVarNameInTable="columnsurname" msprop:Generator_ColumnPropNameInRow="surname" msprop:Generator_ColumnPropNameInTable="surnameColumn" msprop:Generator_UserColumnName="surname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DOB" msprop:Generator_ColumnVarNameInTable="columnDOB" msprop:Generator_ColumnPropNameInRow="DOB" msprop:Generator_ColumnPropNameInTable="DOBColumn" msprop:Generator_UserColumnName="DOB" type="xs:dateTime" />
              <xs:element name="nationality" msprop:Generator_ColumnVarNameInTable="columnnationality" msprop:Generator_ColumnPropNameInRow="nationality" msprop:Generator_ColumnPropNameInTable="nationalityColumn" msprop:Generator_UserColumnName="nationality">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="home_town" msprop:Generator_ColumnVarNameInTable="columnhome_town" msprop:Generator_ColumnPropNameInRow="home_town" msprop:Generator_ColumnPropNameInTable="home_townColumn" msprop:Generator_UserColumnName="home_town">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="street_address" msprop:Generator_ColumnVarNameInTable="columnstreet_address" msprop:Generator_ColumnPropNameInRow="street_address" msprop:Generator_ColumnPropNameInTable="street_addressColumn" msprop:Generator_UserColumnName="street_address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="postcode" msprop:Generator_ColumnVarNameInTable="columnpostcode" msprop:Generator_ColumnPropNameInRow="postcode" msprop:Generator_ColumnPropNameInTable="postcodeColumn" msprop:Generator_UserColumnName="postcode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="city" msprop:Generator_ColumnVarNameInTable="columncity" msprop:Generator_ColumnPropNameInRow="city" msprop:Generator_ColumnPropNameInTable="cityColumn" msprop:Generator_UserColumnName="city">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mobile_number" msprop:Generator_ColumnVarNameInTable="columnmobile_number" msprop:Generator_ColumnPropNameInRow="mobile_number" msprop:Generator_ColumnPropNameInTable="mobile_numberColumn" msprop:Generator_UserColumnName="mobile_number">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telephone_number" msprop:Generator_ColumnVarNameInTable="columntelephone_number" msprop:Generator_ColumnPropNameInRow="telephone_number" msprop:Generator_ColumnPropNameInTable="telephone_numberColumn" msprop:Generator_UserColumnName="telephone_number">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email_address" msprop:Generator_ColumnVarNameInTable="columnemail_address" msprop:Generator_ColumnPropNameInRow="email_address" msprop:Generator_ColumnPropNameInTable="email_addressColumn" msprop:Generator_UserColumnName="email_address">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="role" msprop:Generator_ColumnVarNameInTable="columnrole" msprop:Generator_ColumnPropNameInRow="role" msprop:Generator_ColumnPropNameInTable="roleColumn" msprop:Generator_UserColumnName="role">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_employment_from" msprop:Generator_ColumnVarNameInTable="columndate_employment_from" msprop:Generator_ColumnPropNameInRow="date_employment_from" msprop:Generator_ColumnPropNameInTable="date_employment_fromColumn" msprop:Generator_UserColumnName="date_employment_from" type="xs:dateTime" />
              <xs:element name="date_employment_to" msprop:Generator_ColumnVarNameInTable="columndate_employment_to" msprop:Generator_ColumnPropNameInRow="date_employment_to" msprop:Generator_ColumnPropNameInTable="date_employment_toColumn" msprop:Generator_UserColumnName="date_employment_to" type="xs:dateTime" />
              <xs:element name="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" msprop:Generator_UserColumnName="status">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="reason_dormancy" msprop:Generator_ColumnVarNameInTable="columnreason_dormancy" msprop:Generator_ColumnPropNameInRow="reason_dormancy" msprop:Generator_ColumnPropNameInTable="reason_dormancyColumn" msprop:Generator_UserColumnName="reason_dormancy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WEEK" msprop:Generator_TableClassName="WEEKDataTable" msprop:Generator_TableVarName="tableWEEK" msprop:Generator_RowChangedName="WEEKRowChanged" msprop:Generator_TablePropName="WEEK" msprop:Generator_RowDeletingName="WEEKRowDeleting" msprop:Generator_RowChangingName="WEEKRowChanging" msprop:Generator_RowEvHandlerName="WEEKRowChangeEventHandler" msprop:Generator_RowDeletedName="WEEKRowDeleted" msprop:Generator_RowClassName="WEEKRow" msprop:Generator_UserTableName="WEEK" msprop:Generator_RowEvArgName="WEEKRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id_Week" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid_Week" msprop:Generator_ColumnPropNameInRow="id_Week" msprop:Generator_ColumnPropNameInTable="id_WeekColumn" msprop:Generator_UserColumnName="id_Week" type="xs:int" />
              <xs:element name="day" msprop:Generator_ColumnVarNameInTable="columnday" msprop:Generator_ColumnPropNameInRow="day" msprop:Generator_ColumnPropNameInTable="dayColumn" msprop:Generator_UserColumnName="day" type="xs:dateTime" />
              <xs:element name="week_number" msprop:Generator_ColumnVarNameInTable="columnweek_number" msprop:Generator_ColumnPropNameInRow="week_number" msprop:Generator_ColumnPropNameInTable="week_numberColumn" msprop:Generator_UserColumnName="week_number">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PERSON" msprop:Generator_TableClassName="PERSONDataTable" msprop:Generator_TableVarName="tablePERSON" msprop:Generator_RowChangedName="PERSONRowChanged" msprop:Generator_TablePropName="PERSON" msprop:Generator_RowDeletingName="PERSONRowDeleting" msprop:Generator_RowChangingName="PERSONRowChanging" msprop:Generator_RowEvHandlerName="PERSONRowChangeEventHandler" msprop:Generator_RowDeletedName="PERSONRowDeleted" msprop:Generator_RowClassName="PERSONRow" msprop:Generator_UserTableName="PERSON" msprop:Generator_RowEvArgName="PERSONRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="person_name" msprop:Generator_ColumnVarNameInTable="columnperson_name" msprop:Generator_ColumnPropNameInRow="person_name" msprop:Generator_ColumnPropNameInTable="person_nameColumn" msprop:Generator_UserColumnName="person_name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="person_surname" msprop:Generator_ColumnVarNameInTable="columnperson_surname" msprop:Generator_ColumnPropNameInRow="person_surname" msprop:Generator_ColumnPropNameInTable="person_surnameColumn" msprop:Generator_UserColumnName="person_surname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EVENT_VIEW" msprop:Generator_TableClassName="EVENT_VIEWDataTable" msprop:Generator_TableVarName="tableEVENT_VIEW" msprop:Generator_TablePropName="EVENT_VIEW" msprop:Generator_RowDeletingName="EVENT_VIEWRowDeleting" msprop:Generator_RowChangingName="EVENT_VIEWRowChanging" msprop:Generator_RowEvHandlerName="EVENT_VIEWRowChangeEventHandler" msprop:Generator_RowDeletedName="EVENT_VIEWRowDeleted" msprop:Generator_UserTableName="EVENT_VIEW" msprop:Generator_RowChangedName="EVENT_VIEWRowChanged" msprop:Generator_RowEvArgName="EVENT_VIEWRowChangeEvent" msprop:Generator_RowClassName="EVENT_VIEWRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="event_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnevent_ID" msprop:Generator_ColumnPropNameInRow="event_ID" msprop:Generator_ColumnPropNameInTable="event_IDColumn" msprop:Generator_UserColumnName="event_ID" type="xs:int" />
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date" msprop:Generator_ColumnVarNameInTable="columndate" msprop:Generator_ColumnPropNameInRow="date" msprop:Generator_ColumnPropNameInTable="dateColumn" msprop:Generator_UserColumnName="date" type="xs:dateTime" />
              <xs:element name="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" msprop:Generator_UserColumnName="time" type="xs:duration" />
              <xs:element name="priority" msprop:Generator_ColumnVarNameInTable="columnpriority" msprop:Generator_ColumnPropNameInRow="priority" msprop:Generator_ColumnPropNameInTable="priorityColumn" msprop:Generator_UserColumnName="priority">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="STUDENT_student_ID" msprop:Generator_ColumnVarNameInTable="columnSTUDENT_student_ID" msprop:Generator_ColumnPropNameInRow="STUDENT_student_ID" msprop:Generator_ColumnPropNameInTable="STUDENT_student_IDColumn" msprop:Generator_UserColumnName="STUDENT_student_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="STAFF_staff_ID" msprop:Generator_ColumnVarNameInTable="columnSTAFF_staff_ID" msprop:Generator_ColumnPropNameInRow="STAFF_staff_ID" msprop:Generator_ColumnPropNameInTable="STAFF_staff_IDColumn" msprop:Generator_UserColumnName="STAFF_staff_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="STUDENT_GRADE" msprop:Generator_TableClassName="STUDENT_GRADEDataTable" msprop:Generator_TableVarName="tableSTUDENT_GRADE" msprop:Generator_TablePropName="STUDENT_GRADE" msprop:Generator_RowDeletingName="STUDENT_GRADERowDeleting" msprop:Generator_RowChangingName="STUDENT_GRADERowChanging" msprop:Generator_RowEvHandlerName="STUDENT_GRADERowChangeEventHandler" msprop:Generator_RowDeletedName="STUDENT_GRADERowDeleted" msprop:Generator_UserTableName="STUDENT_GRADE" msprop:Generator_RowChangedName="STUDENT_GRADERowChanged" msprop:Generator_RowEvArgName="STUDENT_GRADERowChangeEvent" msprop:Generator_RowClassName="STUDENT_GRADERow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="student_ID" msprop:Generator_ColumnVarNameInTable="columnstudent_ID" msprop:Generator_ColumnPropNameInRow="student_ID" msprop:Generator_ColumnPropNameInTable="student_IDColumn" msprop:Generator_UserColumnName="student_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="surname" msprop:Generator_ColumnVarNameInTable="columnsurname" msprop:Generator_ColumnPropNameInRow="surname" msprop:Generator_ColumnPropNameInTable="surnameColumn" msprop:Generator_UserColumnName="surname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="weighting_percentage" msprop:Generator_ColumnVarNameInTable="columnweighting_percentage" msprop:Generator_ColumnPropNameInRow="weighting_percentage" msprop:Generator_ColumnPropNameInTable="weighting_percentageColumn" msprop:Generator_UserColumnName="weighting_percentage" type="xs:int" />
              <xs:element name="grade" msprop:Generator_ColumnVarNameInTable="columngrade" msprop:Generator_ColumnPropNameInRow="grade" msprop:Generator_ColumnPropNameInTable="gradeColumn" msprop:Generator_UserColumnName="grade">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_submission" msprop:Generator_ColumnVarNameInTable="columndate_submission" msprop:Generator_ColumnPropNameInRow="date_submission" msprop:Generator_ColumnPropNameInTable="date_submissionColumn" msprop:Generator_UserColumnName="date_submission" type="xs:dateTime" />
              <xs:element name="module_Code" msprop:Generator_ColumnVarNameInTable="columnmodule_Code" msprop:Generator_ColumnPropNameInRow="module_Code" msprop:Generator_ColumnPropNameInTable="module_CodeColumn" msprop:Generator_UserColumnName="module_Code">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="module_Title" msprop:Generator_ColumnVarNameInTable="columnmodule_Title" msprop:Generator_ColumnPropNameInRow="module_Title" msprop:Generator_ColumnPropNameInTable="module_TitleColumn" msprop:Generator_UserColumnName="module_Title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="course_Title" msprop:Generator_ColumnVarNameInTable="columncourse_Title" msprop:Generator_ColumnPropNameInRow="course_Title" msprop:Generator_ColumnPropNameInTable="course_TitleColumn" msprop:Generator_UserColumnName="course_Title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:STUDENT" />
      <xs:field xpath="mstns:student_ID" />
    </xs:unique>
    <xs:unique name="ASSESSMENT_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ASSESSMENT" />
      <xs:field xpath="mstns:assessment_ID" />
    </xs:unique>
    <xs:unique name="ASSIGNED_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ASSIGNED" />
      <xs:field xpath="mstns:assigned_ID" />
    </xs:unique>
    <xs:unique name="CONCERN_LETTER_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CONCERN_LETTER" />
      <xs:field xpath="mstns:letter_ID" />
    </xs:unique>
    <xs:unique name="COURSE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:COURSE" />
      <xs:field xpath="mstns:course_Code" />
    </xs:unique>
    <xs:unique name="EVENT_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EVENT" />
      <xs:field xpath="mstns:event_ID" />
      <xs:field xpath="mstns:date" />
      <xs:field xpath="mstns:time" />
    </xs:unique>
    <xs:unique name="MODULE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MODULE" />
      <xs:field xpath="mstns:module_Code" />
    </xs:unique>
    <xs:unique name="PERSONAL_TUTORIAL_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PERSONAL_TUTORIAL" />
      <xs:field xpath="mstns:pt_ID" />
    </xs:unique>
    <xs:unique name="QUALIFICATION_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:QUALIFICATION" />
      <xs:field xpath="mstns:id_Qualification" />
      <xs:field xpath="mstns:subject" />
    </xs:unique>
    <xs:unique name="REGISTER_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:REGISTER" />
      <xs:field xpath="mstns:register_ID" />
    </xs:unique>
    <xs:unique name="RESULT_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RESULT" />
      <xs:field xpath="mstns:result_ID" />
    </xs:unique>
    <xs:unique name="ROOM_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ROOM" />
      <xs:field xpath="mstns:room_ID" />
    </xs:unique>
    <xs:unique name="SLOT_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SLOT" />
      <xs:field xpath="mstns:slot_ID" />
    </xs:unique>
    <xs:unique name="STAFF_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:STAFF" />
      <xs:field xpath="mstns:staff_ID" />
    </xs:unique>
    <xs:unique name="WEEK_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WEEK" />
      <xs:field xpath="mstns:id_Week" />
      <xs:field xpath="mstns:day" />
    </xs:unique>
    <xs:unique name="EVENT_VIEW_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:EVENT_VIEW" />
      <xs:field xpath="mstns:event_ID" />
      <xs:field xpath="mstns:date" />
      <xs:field xpath="mstns:time" />
    </xs:unique>
    <xs:unique name="STUDENT_GRADE_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:STUDENT_GRADE" />
      <xs:field xpath="mstns:student_ID" />
      <xs:field xpath="mstns:module_Code" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="fk_assessment_module1" msdata:parent="MODULE" msdata:child="ASSESSMENT" msdata:parentkey="module_Code" msdata:childkey="MODULE_module_Code" msprop:Generator_UserChildTable="ASSESSMENT" msprop:Generator_ChildPropName="GetASSESSMENTRows" msprop:Generator_UserRelationName="fk_assessment_module1" msprop:Generator_ParentPropName="MODULERow" msprop:Generator_RelationVarName="relationfk_assessment_module1" msprop:Generator_UserParentTable="MODULE" />
      <msdata:Relationship name="fk_assigned_module1" msdata:parent="MODULE" msdata:child="ASSIGNED" msdata:parentkey="module_Code" msdata:childkey="MODULE_module_Code" msprop:Generator_UserChildTable="ASSIGNED" msprop:Generator_ChildPropName="GetASSIGNEDRows" msprop:Generator_UserRelationName="fk_assigned_module1" msprop:Generator_ParentPropName="MODULERow" msprop:Generator_RelationVarName="relationfk_assigned_module1" msprop:Generator_UserParentTable="MODULE" />
      <msdata:Relationship name="fk_assigned_student1" msdata:parent="STUDENT" msdata:child="ASSIGNED" msdata:parentkey="student_ID" msdata:childkey="STUDENT_student_ID" msprop:Generator_UserChildTable="ASSIGNED" msprop:Generator_ChildPropName="GetASSIGNEDRows" msprop:Generator_UserRelationName="fk_assigned_student1" msprop:Generator_RelationVarName="relationfk_assigned_student1" msprop:Generator_UserParentTable="STUDENT" msprop:Generator_ParentPropName="STUDENTRow" />
      <msdata:Relationship name="fk_attend_slot1" msdata:parent="SLOT" msdata:child="ASSIGNED" msdata:parentkey="slot_ID" msdata:childkey="SLOT_slot_ID" msprop:Generator_UserChildTable="ASSIGNED" msprop:Generator_ChildPropName="GetASSIGNEDRows" msprop:Generator_UserRelationName="fk_attend_slot1" msprop:Generator_ParentPropName="SLOTRow" msprop:Generator_RelationVarName="relationfk_attend_slot1" msprop:Generator_UserParentTable="SLOT" />
      <msdata:Relationship name="fk_concern_letter_student1" msdata:parent="STUDENT" msdata:child="CONCERN_LETTER" msdata:parentkey="student_ID" msdata:childkey="STUDENT_student_ID" msprop:Generator_UserChildTable="CONCERN_LETTER" msprop:Generator_ChildPropName="GetCONCERN_LETTERRows" msprop:Generator_UserRelationName="fk_concern_letter_student1" msprop:Generator_RelationVarName="relationfk_concern_letter_student1" msprop:Generator_UserParentTable="STUDENT" msprop:Generator_ParentPropName="STUDENTRow" />
      <msdata:Relationship name="fk_module_course1" msdata:parent="COURSE" msdata:child="MODULE" msdata:parentkey="course_Code" msdata:childkey="COURSE_course_Code" msprop:Generator_UserChildTable="MODULE" msprop:Generator_ChildPropName="GetMODULERows" msprop:Generator_UserRelationName="fk_module_course1" msprop:Generator_RelationVarName="relationfk_module_course1" msprop:Generator_UserParentTable="COURSE" msprop:Generator_ParentPropName="COURSERow" />
      <msdata:Relationship name="fk_personal_tutorial_staff1" msdata:parent="STAFF" msdata:child="PERSONAL_TUTORIAL" msdata:parentkey="staff_ID" msdata:childkey="STAFF_staff_ID" msprop:Generator_UserChildTable="PERSONAL_TUTORIAL" msprop:Generator_ChildPropName="GetPERSONAL_TUTORIALRows" msprop:Generator_UserRelationName="fk_personal_tutorial_staff1" msprop:Generator_ParentPropName="STAFFRow" msprop:Generator_RelationVarName="relationfk_personal_tutorial_staff1" msprop:Generator_UserParentTable="STAFF" />
      <msdata:Relationship name="fk_personal_tutorial_student1" msdata:parent="STUDENT" msdata:child="PERSONAL_TUTORIAL" msdata:parentkey="student_ID" msdata:childkey="STUDENT_student_ID" msprop:Generator_UserChildTable="PERSONAL_TUTORIAL" msprop:Generator_ChildPropName="GetPERSONAL_TUTORIALRows" msprop:Generator_UserRelationName="fk_personal_tutorial_student1" msprop:Generator_RelationVarName="relationfk_personal_tutorial_student1" msprop:Generator_UserParentTable="STUDENT" msprop:Generator_ParentPropName="STUDENTRow" />
      <msdata:Relationship name="fk_qualification_student" msdata:parent="STUDENT" msdata:child="QUALIFICATION" msdata:parentkey="student_ID" msdata:childkey="STUDENT_student_ID" msprop:Generator_UserChildTable="QUALIFICATION" msprop:Generator_ChildPropName="GetQUALIFICATIONRows" msprop:Generator_UserRelationName="fk_qualification_student" msprop:Generator_RelationVarName="relationfk_qualification_student" msprop:Generator_UserParentTable="STUDENT" msprop:Generator_ParentPropName="STUDENTRow" />
      <msdata:Relationship name="fk_attendance_module1" msdata:parent="MODULE" msdata:child="REGISTER" msdata:parentkey="module_Code" msdata:childkey="MODULE_module_Code" msprop:Generator_UserChildTable="REGISTER" msprop:Generator_ChildPropName="GetREGISTERRows" msprop:Generator_UserRelationName="fk_attendance_module1" msprop:Generator_RelationVarName="relationfk_attendance_module1" msprop:Generator_UserParentTable="MODULE" msprop:Generator_ParentPropName="MODULERow" />
      <msdata:Relationship name="fk_register_student1" msdata:parent="STUDENT" msdata:child="REGISTER" msdata:parentkey="student_ID" msdata:childkey="STUDENT_student_ID" msprop:Generator_UserChildTable="REGISTER" msprop:Generator_ChildPropName="GetREGISTERRows" msprop:Generator_UserRelationName="fk_register_student1" msprop:Generator_RelationVarName="relationfk_register_student1" msprop:Generator_UserParentTable="STUDENT" msprop:Generator_ParentPropName="STUDENTRow" />
      <msdata:Relationship name="fk_register_week1" msdata:parent="WEEK" msdata:child="REGISTER" msdata:parentkey="id_Week" msdata:childkey="WEEK_id_Week" msprop:Generator_UserChildTable="REGISTER" msprop:Generator_ChildPropName="GetREGISTERRows" msprop:Generator_UserRelationName="fk_register_week1" msprop:Generator_ParentPropName="WEEKRow" msprop:Generator_RelationVarName="relationfk_register_week1" msprop:Generator_UserParentTable="WEEK" />
      <msdata:Relationship name="fk_complete_assessment1" msdata:parent="ASSESSMENT" msdata:child="RESULT" msdata:parentkey="assessment_ID" msdata:childkey="ASSESSMENT_assessment_ID" msprop:Generator_UserChildTable="RESULT" msprop:Generator_ChildPropName="GetRESULTRows" msprop:Generator_UserRelationName="fk_complete_assessment1" msprop:Generator_RelationVarName="relationfk_complete_assessment1" msprop:Generator_UserParentTable="ASSESSMENT" msprop:Generator_ParentPropName="ASSESSMENTRow" />
      <msdata:Relationship name="fk_complete_student1" msdata:parent="STUDENT" msdata:child="RESULT" msdata:parentkey="student_ID" msdata:childkey="STUDENT_student_ID" msprop:Generator_UserChildTable="RESULT" msprop:Generator_ChildPropName="GetRESULTRows" msprop:Generator_UserRelationName="fk_complete_student1" msprop:Generator_RelationVarName="relationfk_complete_student1" msprop:Generator_UserParentTable="STUDENT" msprop:Generator_ParentPropName="STUDENTRow" />
      <msdata:Relationship name="fk_slot_room1" msdata:parent="ROOM" msdata:child="SLOT" msdata:parentkey="room_ID" msdata:childkey="ROOM_room_ID" msprop:Generator_UserChildTable="SLOT" msprop:Generator_ChildPropName="GetSLOTRows" msprop:Generator_UserRelationName="fk_slot_room1" msprop:Generator_RelationVarName="relationfk_slot_room1" msprop:Generator_UserParentTable="ROOM" msprop:Generator_ParentPropName="ROOMRow" />
      <msdata:Relationship name="fk_timetable_module1" msdata:parent="MODULE" msdata:child="SLOT" msdata:parentkey="module_Code" msdata:childkey="MODULE_module_Code" msprop:Generator_UserChildTable="SLOT" msprop:Generator_ChildPropName="GetSLOTRows" msprop:Generator_UserRelationName="fk_timetable_module1" msprop:Generator_RelationVarName="relationfk_timetable_module1" msprop:Generator_UserParentTable="MODULE" msprop:Generator_ParentPropName="MODULERow" />
      <msdata:Relationship name="fk_student_course" msdata:parent="COURSE" msdata:child="STUDENT" msdata:parentkey="course_Code" msdata:childkey="COURSE_course_Code" msprop:Generator_UserChildTable="STUDENT" msprop:Generator_ChildPropName="GetSTUDENTRows" msprop:Generator_UserRelationName="fk_student_course" msprop:Generator_ParentPropName="COURSERow" msprop:Generator_RelationVarName="relationfk_student_course" msprop:Generator_UserParentTable="COURSE" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>